﻿<?xml version="1.0" encoding="utf-8" ?>
<objects xmlns="http://www.springframework.net">
  <object id="MacroToProcess" type="Macro" >
    <constructor-arg name="templateId"
                     value="{41C24948-B23C-4acf-B773-00FA3FF53751}" />
    <constructor-arg name="actions">
      <list element-type="IAction">
        <!-- ================ -->
        <!-- Run Some SQL     -->
        <!-- ================ -->
        <object name="ExecSQL1" type="Action.ExecuteSQL">
          <property name="EntityList">
            <object type="Entity.SQLScriptInfo">

              <!-- This Script will be run during the "Do" -->
              <property name="DoScript">
                <object type="Entity.SQLScript">
                  <property name="ConnectionString" value="Data Source=.;Initial Catalog=master;Integrated Security=SSPI" />
                  <property name="Timeout" value="60" />
                  <property name="ScriptText" value="SELECT * FROM sys.tables" />
                </object>
              </property>

              <!-- This Script will be run during the "Undo" -->
              <property name="UndoScript">
                <object type="Entity.SQLScript">
                  <property name="ConnectionString" value="Data Source=.;Initial Catalog=master;Integrated Security=SSPI" />
                  <property name="Timeout" value="60" />
                  <property name="ScriptText" value="SELECT * FROM sys.sysobjects" />
                </object>
              </property>

            </object>
          </property>
          <property name="StopOnDoException" value="true"/>
          <property name="StopOnUndoException" value="true"/>         
        </object>
      </list>
    </constructor-arg>
    <property name="AutoUndo" value="true"/>
  </object>
</objects>

